/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 votes163 views3 answers
Rename column ORACLE
SQL
0 vote132 views4 answers
Postgresql between month
SQL
1 vote125 views1 answer
Mysql login console
SQL
6 votes118 views2 answers
How to copy data in sql
SQL
1 vote122 views1 answer
Get url of cpanel database hostname
SQL
0 vote120 views1 answer
Error code 1241 mysql
SQL
0 vote209 views1 answer
Mssql unique key accept nulls
SQL
18 votes127 views3 answers
Find column name in database
SQL
1 vote130 views1 answer
Table information in sql server
SQL
0 vote124 views1 answer
Postgresql update to unique
SQL

Share