/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

6 votes381 views3 answers
How to delete table sqlite
SQL
2 votes346 views1 answer
Oracle create directory
SQL
7 votes323 views1 answer
Grant schema permissions postgres
SQL
5 votes343 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote347 views1 answer
Mssql now diff 90 day
SQL
0 vote369 views1 answer
Oracle table privileges
SQL
0 vote326 views1 answer
Postgres add prefix to primary key
SQL
6 votes348 views5 answers
Mysql get last insert id
SQL
-1 vote366 views1 answer
Utf8_encode mysql
SQL
0 vote389 views1 answer
Dataframe lambda elif
SQL

Share