/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 vote352 views1 answer
Split string by comma in sql server
SQL
3 votes335 views3 answers
List columns in table postgres
SQL
11 votes337 views1 answer
Get ddl materialized view oracle
SQL
0 vote349 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote337 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
1 vote316 views1 answer
How to print longest name in sql
SQL
0 vote372 views1 answer
Mysqldump: error:
SQL
13 votes311 views2 answers
Display users in mysql
SQL
0 vote334 views1 answer
Mysql persistence.xml
SQL
0 vote372 views2 answers
Mysql dump database tables only
SQL

Share