/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

2 votes240 views2 answers
Change varchar length mysql
SQL
2 votes228 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote192 views1 answer
Oracle sql developer script output limit
SQL
21 votes236 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
52 votes377 views6 answers
Rename column sql
SQL
0 vote229 views2 answers
Sqlite
SQL
0 vote248 views1 answer
Ajax error exception handeling
SQL
5 votes221 views1 answer
Oracle get nls settings
SQL
36 votes254 views6 answers
Delete from where sql
SQL
-1 vote233 views1 answer
Condition in orderby mysql
SQL

Share