Just a Web Code Solution
How use not like in sql ?
131
SQL
0
By 10 years ago
The power of the user (%)
0
column1
sprite
fanta
cola
pepsicola
SELECT * FROM table1
WHERE column1 NOT LIKE '%ol% ';
result:
sprite
fanta
By 10 years ago
The power of the user (%)
The most helpful SQL solutions
how to execute select into using sql ?SQL
Click to see more ...
744
53
convert string to date sqlSQL
Click to see more ...
656
42
How to get the last record from table using sql ?SQL
Click to see more ...
568
33
create table sqlSQL
Click to see more ...
344
23
How use like using sql ?SQL
Click to see more ...
428
22
How to get the last 10 records using mysql ?SQL
Click to see more ...
321
21
rows to columns sqlSQL
Click to see more ...
275
17
insert new column into table sqlSQL
Click to see more ...
276
16
How to convert the values to lowercase using sql ?SQL
Click to see more ...
295
13
How to change a negative number to positive using sql ?SQL
Click to see more ...
229
11
- Related solutions:
- How to use now plus 1 year using mysql ?
194 1 - How to use now plus 1 month using mysql ?
209 0 - How to use now plus 1 day using mysql ?
202 0 - How to specify multiple values in a WHERE clause using sql ?
201 2 - How use not between in sql ?
202 0 -
Vote
0
- Latest solutions:
- create table sql
344 23 - insert new column into table sql
276 16 - rename column sql
237 3 - convert string to date sql
656 42 - get date from datetime sql
208 1 - get part of a string sql
217 0 - select year from datetime sql
227 1 - create table from select sql
259 3 - rows to columns sql
275 17 - delete table from databse sql
215 1 - Helpful solutions:
- how to execute select into using sql ?
744 53 - convert string to date sql
656 42 - How to get the last record from table using sql ?
568 33 - create table sql
344 23 - How use like using sql ?
428 22 - How to get the last 10 records using mysql ?
321 21 - rows to columns sql
275 17 - insert new column into table sql
276 16 - How to convert the values to lowercase using sql ?
295 13 - How to change a negative number to positive using sql ?
229 11
SQL
Would you like to receive an e-mail notification when new SQL solution is created?