/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 vote192 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote183 views1 answer
Oracle SQL join three tables and group by column
SQL
4 votes177 views1 answer
What are the data types in sql
SQL
1 vote186 views4 answers
Sequelize migration default value
SQL
0 vote182 views1 answer
How to display value of variable in mysql
SQL
1 vote166 views1 answer
Mysql count words
SQL
3 votes218 views1 answer
Laravel paginate raw sql
SQL
18 votes187 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote181 views1 answer
MySQL - How to find word with the most similar beginning
SQL
7 votes167 views3 answers
Add primary key to database sql
SQL

Share