can be done, keep a watch on slow query logs and see if your query is causing significant performance degradation. Syntax CONCAT ( expression1, expression2, expression3 .) Parameter Values Technical Details Works in: From MySQL 4. WHERE a.first_name LIKE '$variable%' or a.last_name LIKE '$variable%' Note: If any of the expressions is a NULL value, it returns NULL. First, if you are on MyISAM or InnoDB 5.6+, you could store the concatenation in a separate field and use a FULLTEXT index on that field. create or replace view document.Documents as select d.documentID ,cu.emailAddress as createdByUser from document.Document as d left join customer.User as cu on cu. can be done, index can be created on firstname and lastname individually and a sanitized variable can be used in the LIKE statement like so: mysql index Share Improve this question Follow asked at 3:31 jmadsen 161 1 4 Add a comment 3 Answers Sorted by: 2 Two options I can think of. Instead of displaying emailAddress column as per below view, I want to display a concat of firstName and lastName columns. In the second statement, the LIKE value is not a constant.Ĭan your application can be modified to search for: For example, to drop multiple columns in a single. It groups your data based on some values and shows these in columns instead. This is a MySQL extension to standard SQL, which permits only one of each clause per ALTER TABLE statement. It’s commonly used in Microsoft Excel where you create a Pivot Table to display data differently. SELECT * FROM tbl_name WHERE key_col LIKE '%Patrick%' and SELECT * FROM tbl_name WHERE key_col LIKE other_col In the first statement, the LIKE value begins with a wildcard character. What is PIVOT The concept of a pivot is where data in rows is transformed to be shown in columns instead. The following SELECT statements do not use indexes:

The query to create a table is as follows.

select CONCAT (yourColumnName1, ,yourColumnName2) as anyVariableName from yourTableName To understand the above concept, let us create a table. If your query is going to look for %something%, an index will not help you on MySQL 5.0. To concatenate two columns, use CONCAT () function in MySQL.

Mysql add column with concated data