/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 vote194 views1 answer
How to use lower case in mysql
SQL
0 vote198 views1 answer
Oracle running queries sql
SQL
0 vote173 views1 answer
Postrgres trunc
SQL
34 votes234 views6 answers
Alter table add foreign key mysql
SQL
49 votes291 views6 answers
Mysql add column to table
SQL
1 vote176 views1 answer
Get count by weekly pivot table sql server
SQL
5 votes206 views1 answer
AND OR NOT operators sql
SQL
2 votes252 views1 answer
Oracle block
SQL
2 votes183 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
1 vote210 views1 answer
How not to sort by average rating
SQL

Share