Lab Sql

Here is my table structure: id PaymentCond 1 ZBE1, AP1, LST2, CC1 2 VB3, CC1, ZBE1 I need to spl… Read more Sql: Split Comma Separated String List With A Query?

How can I match the whole word in mysql? For instance, if I type in 'lau', I don't want… Read more Mysql Regexp To Match The Whole Word Only

I have a table in a SQL Server database which has a column ColumnStrings with strings of this kind:… Read more Sql Server: How To Find The Substring Just After The Last Occurence Of Another Substring And Before The Next Comma

Both of these queries will produce same result. But which one is better, faster. SELECT LEFT(textFi… Read more Mysql Left() Or Substring()?

I need to remove the second appearance of a substring from the main string, IF both substrings are … Read more Remove Second Appearence Of A Substring From String In Sql Server

I need a SQL query to get two charstrings from one main string, the returned values start with T###… Read more A Sql Query To Select Two Substrings From A Known String

Is it possible to combine the use of back ticks ` with the substr() function? I have column names w… Read more Mysql Query Column Name Substring

I need to get a substring from a column 'source' from typeTable and be able to get stats on… Read more Sql Server: Group Query Based On Substring Of Column