**What Will I Learn?**   
In this video you will learn how to use The instr, left, right, lpad and rpad commands on tables created in the MySQL Database. With these commands, you will learn to perform faster and easier operations in the database.   

**Requirements**   
Your computer should be one of the following operating systems.   
• Windows 32 - 64   
• Linux   
• MacOS   
• The MySQL program is required to run this application.   
MySQL download link:  https://dev.mysql.com/downloads/mysql/   

**Difficulty**   
• Intermediate   

**Description**   
The content of this video includes the detailed use of **MySQL**, a database management system.
You will see a very fast and comfortable operation in the table created in the MySQL program with the commands I will show in this application.    

In this video you will see how many times the specified word is used in the selected column.
In this application, you will see how much information we want in the selected column. This information can be from the beginning or end of the line.   

In this application, you can add new information to the entire selected column and see how much information we want in the column. If the character limitation is high, it adds the word to be inserted repeatedly.   

**Commands I Use**   
•	Instr: Searches for the word specified in the column and finds how many it is.   
•	Left: Displays information as much as the desired character to the left of the selected column.   
•	Right: Displays information from the right of the selected column as much as the desired character.   
•	Lpad: Adds new information to the left of the selected column. It repeats as many times as it is said.   
•	Rpad: Adds new information to the right of the selected column. It repeats as many times as it is said.   

**Video Tutorial - English Language - 720p**   

https://youtu.be/94Xqid6l89A

**Curriculum**    

•	[Creating a database with MySQL, connecting to a database, creating a table]( https://utopian.io/utopian-io/@omur61/mysql-ile-veri-tabani-olusturma-veri-tabanina-baglanma-tablo-olusturma-tabloya-veri-girisi-yapma-ve-goeruentueleme-uygulamasi) (TR)

•	[The “update” and “delete” functions in the database with MySQL]( https://utopian.io/utopian-io/@omur61/mysql-ile-veri-tabaninda-update-ve-delete-fonksiyonlarinin-uygulamasi-turkish-video-tutorial) (TR)

•	[“Alter” and “drop” functions that provide structural changes to the database with MySQL]( https://utopian.io/utopian-io/@omur61/mysql-ile-veri-tabaninda-yapisal-degisiklik-saglayan-alter-ve-drop-fonksiyonlarinin-uygulamasi-turkish-video-tutorial) (TR)

•	[Primary key assignment to tables in the database with MySQL, primary key properties]( https://utopian.io/utopian-io/@omur61/mysql-ile-veri-tabaninda-tabloya-primary-key-atama-primary-key-oezellikleri-ve-hata-coezuemleri-uygulamasi-turkish-video) (TR)

•	[Relationship of three tables with foreign key function in MySQL database]( https://utopian.io/utopian-io/@omur61/mysql-ile-veri-tabaninda-foreign-key-fonksiyonu-ile-3-tablonun-birbiriyle-iliskilendirme-uygulamasi-turkish-video-tutorial) (TR)

•	[Create an application using with As, In , Like, Limit and Sum commands on the MySQL database]( https://utopian.io/utopian-io/@omur61/create-an-application-using-with-as-in-like-limit-and-sum-commands-on-the-mysql-database) (ENG)

•	[Create an application using with Max, Min , Group by, Is null and Is not null commands on the MySQL database]( https://utopian.io/utopian-io/@omur61/create-an-application-using-with-max-min-group-by-is-null-and-is-not-null-commands-on-the-mysql-database) (ENG)

•	[Create an application using with Mid, Length , Round, Replace, Upper and Lower commands on the MySQL database]( https://utopian.io/utopian-io/@omur61/create-an-application-using-with-mid-length-round-replace-upper-and-lower-commands-on-the-mysql-database) (ENG)

•	[Create an application using with Concat, Concat_ws , Field, Find_In_Set and Ascii commands on the MySQL]( https://utopian.io/utopian-io/@omur61/create-an-application-using-with-concat-concatws-field-findinset-and-ascii-commands-on-the-mysql-database) (ENG)



[GitHub Address Of Application]( https://github.com/mysqljs/mysql)


<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@omur61/create-an-application-using-with-instr-left-right-lpad-and-rpad-commands-on-the-mysql-database">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>