/SQL/Mysql keyword search

Mysql keyword search

Sql searching via key word

SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')

0

Source: stackoverflow.com

Sql searching via key word

SELECT id, category, location
FROM table
WHERE
(
    category LIKE '%keyword%'
    OR location LIKE '%keyword%'
)

0

Source: stackoverflow.com

Mysql keyword search

SELECT title, description
FROM film
WHERE
(
    title LIKE '%Drama%'
    OR description LIKE '%Drama%'
);

0

Source: stackoverflow.com

Similar codes

0 vote311 views1 answer
How to add session data into mysql database from button
SQL
20 votes323 views6 answers
Change password in mysql
SQL
12 votes270 views4 answers
SQL Where
SQL
1 vote281 views1 answer
Oracle sql create or replace view
SQL
1 vote276 views1 answer
Mysql server does not start mac
SQL
1 vote306 views2 answers
Find nth highest salary of an employee
SQL
11 votes278 views2 answers
Sql rank
SQL
0 vote361 views1 answer
Python get backup of sql
SQL
0 vote288 views2 answers
Find lowest number in sql
SQL
1 vote272 views1 answer
Postgresql convert text to float
SQL

Share