/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 vote191 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
58 votes525 views6 answers
Create new user in postgres
SQL
0 vote262 views1 answer
Get last inserted primary key
SQL
1 vote167 views1 answer
How to install mysql 8.0 windows service
SQL
7 votes214 views2 answers
Create index mysql cli
SQL
2 votes167 views1 answer
Get first n letter of department name in sql
SQL
9 votes174 views4 answers
How to alter table column name in mysql
SQL
0 vote230 views5 answers
Right join
SQL
5 votes224 views1 answer
Purge undo tablespace usage
SQL
20 votes175 views1 answer
Sql change column types
SQL

Share