Skip to content Skip to sidebar Skip to footer
Showing posts with the label Substring
Sql: Split Comma Separated String List With A Query?

Sql: Split Comma Separated String List With A Query?

Post a Comment
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?
Mysql Regexp To Match The Whole Word Only

Mysql Regexp To Match The Whole Word Only

Post a Comment
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
Sql Server: How To Find The Substring Just After The Last Occurence Of Another Substring And Before The Next Comma

Sql Server: How To Find The Substring Just After The Last Occurence Of Another Substring And Before The Next Comma

Post a Comment
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
Mysql Left() Or Substring()?

Mysql Left() Or Substring()?

Post a Comment
Both of these queries will produce same result. But which one is better, faster. SELECT LEFT(textFi… Read more Mysql Left() Or Substring()?
Remove Second Appearence Of A Substring From String In Sql Server

Remove Second Appearence Of A Substring From String In Sql Server

Post a Comment
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
A Sql Query To Select Two Substrings From A Known String

A Sql Query To Select Two Substrings From A Known String

Post a Comment
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