SELECT * FROM table WHERE "substring" IN table_field?

loonyuni Published at Dev

loonyuni

id | url
---------
1  | "facebook.com/user"
2  | "stackoverflow.com/question/"
3  | "facebook.com/videos"

So basically I want to extract rows 1 and 2 if I were to try and find urls that have "facebook" in them.

And I'm not sure how to query for that, please help.

Thank you.

Thomas G

Use LIKE operator

SELECT * FROM table WHERE url LIKE '%facebook%'

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-28

Comments

0 comments

From Dev

Select from Table Where field equals a variable

From Dev

Select from mysql table WHERE field in '$array'?

From Dev

SQL SELECT from table when substring is in a string

From Dev

PHP ("SELECT * FROM Table WHERE ... AND ...")

From Dev

SELECT x FROM table WHERE

From Dev

SELECT * FROM table Where CURDATE()

From Dev

SQLite, select where field 'like' field from another table

From Dev

Select field from table A where subselect from table B = table A field

From Dev

Select from table where column in select from another table in laravel

From Dev

Select from table where column in select from another table in laravel

From Dev

BigQuery: select from regexp_match where field in other table

From Dev

Dynamic table name in where clause using a field from select

From Dev

select multiple columns from another table where field contains array

From Dev

Select all columns from table where one field is duplicated

From Dev

SQL, PHP: when submit plus 1 in table_field specified from dropdown

From Dev

SQL, PHP: when submit plus 1 in table_field specified from dropdown

From Dev

MySQL SELECT Substring of rows that do not exist from other TABLE

From Dev

SELECT from table with Varying IN list in WHERE clause

From Dev

Datetime and SELECT * FROM table WHERE date = TODAY

From Dev

JDBC prepared statement select from table where

From Dev

mysql - select from a table with sum() and where clause

From Dev

how select from table where datetime=date

From Dev

Select table from database where value is X

From Dev

select from table where column = any value

From Dev

Select * from table where = "string with linebreaks"

From Dev

select * from table where name like %O%

From Dev

Select from table where the date is later then today

From Dev

select from table where both id exist

From Dev

SQL performance for select from where result of table

Related Related

Article