Question : I have following MySQL db structure: content ======= id | tags ——— 1 | ,abc,def,ghi, 2 | ,abc,foo, […]
Tag: string
Split String Function
Question : I have a question regarding this Split String function Aaron Bertrand recommends here. With it you can extract […]
Using an index for both asc and desc on a string column
Question : I know a trick to make order by queries faster when we want to order by asc and […]
Likes or votes for posts
Question : I am making a small program where users makes posts or write blogs. On those posts, other users […]
Equivalent to PostgreSQL’s Dollar-quoted String Constants for SQL Server
Question : Is there an equivalent of PostgreSQL’s Dollar-quoted String Constants, on SQL Server? I would like to enter HTML […]
MariaDB are bitwise operators defined on strings?
Question : Is the behavior of BITAND, (bitwise and) defined in MariaDB over strings? SELECT ‘0011’ & ‘0011’, ‘ff’ & […]
Performing SQL string manipulations on a single column
Question : I recently came across a problem at an interview which I wasn’t able to answer. The ask was […]
Is there some function in PostgreSQL to simply check if the input string is valid UTF-8 according to PG?
Question : For several years now, I’ve been hunting this extremely quick-footed little bug which knows every hiding place in […]
Return result set as string
Question : I have a table with SELECT fName, lName FROM person It returns 3 results I want to return […]
Replace specific part of a string
Question : I’ve got a table with multiple columns, APGRPID, VIRTKEY, LFDNR and PARAMETERLIST. I want to change a part […]