/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

17 votes332 views6 answers
Sql select distinct
SQL
0 vote361 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
9 votes321 views2 answers
Get first 3 letters in sql
SQL
5 votes399 views1 answer
Oracle drop index if exists
SQL
0 vote340 views1 answer
Mysql drop vs delete
SQL
4 votes335 views1 answer
Change nls_date_format
SQL
2 votes339 views5 answers
SQL trigger
SQL
0 vote326 views1 answer
Select from another database
SQL
0 vote366 views1 answer
How to find the most occuring in SQL
SQL
1 vote372 views1 answer
Isnull sql server
SQL

Share