For examples :
ID - Description
01 - Mix Black
02 - Mix Red
03 - Mix Blue
How I can write a query to show the field like "Mi Bl" in a query?
-
3What RDBMS are you using? Please tag it.David Faber– David Faber2018-03-27 12:31:14 +00:00Commented Mar 27, 2018 at 12:31
-
3You need to edit your question so you're asking for what you actually need or you're going to keep getting answers to the question you asked. stackoverflow.com/help/how-to-askEric Brandt– Eric Brandt2018-03-27 12:39:31 +00:00Commented Mar 27, 2018 at 12:39
Add a comment
|
4 Answers
You can use LIKE with %:
SELECT * FROM your_table WHERE Description LIKE 'Mi%Bl%';
This query would give you these 2 results:
01 - Mix Black
03 - Mix Blue
% is a wildcard:
The percent sign represents zero, one, or multiple characters
3 Comments
Abbas Hodroj
yes and thank you ,but I want to use it in vb project for text edit, so like this it not working
Ronan Boiteau
@AbbasHodroj You could try something like this in Visual Basic:
Dim sql As String = "SELECT * FROM your_table WHERE Description LIKE 'Mi%Bl%'". Not my domain though. Just giving you something I came across that you might find useful. Source: stackoverflow.com/questions/13583209/…Use a LIKE clause with wildcard characters. https://learn.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql
SELECT *
FROM YourTable
WHERE Description LIKE 'Mi%Bl%';
This is SQL Server syntax, but any RDBMS will have a similar wildcard you can use.
1 Comment
Abbas Hodroj
yes and thank you ,but I want to use it in vb project for text edit, so like this it not working
SELECT *
FROM `table`
where Description like '%Mi% %Bl%'
1 Comment
Abbas Hodroj
yes and thank you ,but I want to use it in vb project for text edit, so like this it not working
SELECT *
FROM Tablename
WHERE `Description` LIKE 'Mi%Bl%';
'%' character is used to match any number(0, 1 or more) of characters. So this will match to your below records and result set will be -
ID - Description
-------------------
01 - Mix Black
03 - Mix Blue
5 Comments
Abbas Hodroj
yes and thank you ,but I want to use it in vb project for text edit, so like this it not working
Raj
@a_horse_with_no_name Can you please explain me what is invalid in this SQL?
Raj
@a_horse_with_no_name Thanks! Changed.